package com.ykqx.weather.dao;

import com.ykqx.weather.dto.FYLZ;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * Created with IntelliJ IDEA.
 * User: Legolas
 * Date: 2017/9/4 0004
 */
@Repository
public interface FYLZDao {

    @Select("SELECT top 1 ReportTime,MigrationRate04 FROM ReportInfo WHERE IsMigrationRate04='1' ORDER BY ReportTime DESC")
    FYLZ getFYLZ();

    @Select("SELECT top 24 ReportTime,MigrationRate04 FROM ReportInfo WHERE IsMigrationRate04='1' ORDER BY ReportTime DESC")
    List<FYLZ> getFYLZ24();
}
